{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PUE DP","PUE Other","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":114,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PUE DP","index":0,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2023 Sch B-6A.Z26"]
["09/25/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION  OPERATION & MAINTENANCE EXPENSE AND PROJECT USE ENERGY COST"]
["BY FACILITY AND/OR COMPONENT FOR FY 2023"]
["2025 IRRIGATION WATER RATES"]
[]
["Category","A) Facility/Contractor\n<Ref>","Related Footnotes","B) Unpaid/(Credit) Previous Period","C) Estimated Project Use Energy Cost\nFY2023","D) True-Up\nFY2022","E) Total\nSUM(B:D)","F) Offset: % of Applied *","G) Direct Pumping\nDP Rate x AF","H) Charge Adjustment\nSee Sch B-1","I) Unpaid/ (Remaining)\nSUM(E:H)"]
["Storage (Based on Offset)","San Felipe Unit Contractors","2/",0,517.47,0,517.47,-517.47,"-","-",0]
["Storage (Based on Offset)","All Others","-",0,5679504.4386943998,0,5679504.4386943998,-5679504.4386943998,"-","-",0]
["Total","Storage Total (Based on Offset)","-",0,5680021.9086943995,0,5680021.9086943995,-5680021.9086943995,"-","-",0]
["Direct Pumping (Based on Offset)","Corning WD","-",0,61154.173900000002,0,61154.173900000002,-61154.173900000002,"-","-",0]
["Direct Pumping (Based on Offset)","Cross Valley Canal Contractors (Dos Amigos & Banks)","-",0,10892.9538989424,0,10892.9538989424,-10892.9538989424,"-","-",0]
["Direct Pumping (Based on Offset)","Dunnigan WD","-",0,8000.2740000000003,0,8000.2740000000003,-8000.2740000000003,"-","-",0]
["Direct Pumping (Based on Offset)","Panoche WD","-",0,681.20230000000004,0,681.20230000000004,-681.20230000000004,"-","-",0]
["Direct Pumping (Based on Offset)","Proberta WD","-",0,567.24850000000004,0,567.24850000000004,-567.24850000000004,"-","-",0]
["Direct Pumping (Based on Offset)","Glenn Valley WD","-",0,0,0,0,0,"-","-",0]
["Direct Pumping (Based on Offset)","Westside WD","-",0,23531.0828,0,23531.0828,-23531.0828,"-","-",0]
["Direct Pumping (Based on Offset)","Wintu PP (Bella Vista WD)","-",0,1265.140525566,0,1265.140525566,-1265.140525566,"-","-",0]
["Total","Direct Pumping Total (Based on Offset)","-",0,106092.07592450842,0,106092.07592450842,-106092.07592450842,"-","-",0]
["Direct Pumping (Direct Cost)","Colusa County WD","-",-34877.519210245839,390529.173126382,0,355651.65391613613,"-",-897823.38,542171,-0.72608386387582868]
["Direct Pumping (Direct Cost)","Kanawha WD","-",-0.40073255909373984,30924.441814886901,0,30924.041082327807,"-",-65240.33,34316,-0.28891767219465692]
["Direct Pumping (Direct Cost)","Orland-Artois WD","-",-8.582426821521949E-2,111170.1305,0,111170.04467573178,"-",-184752,0,-73581.955324268216]
["Direct Pumping (Direct Cost)","San Benito County WD","1/, 3/",-192939.14699539827,97497.27315817021,0,-95441.873837228064,"-",-93834.27,0,-189276.14383722807]
["Direct Pumping (Direct Cost)","Santa Clara Valley WD","1/, 3/",-0.91500011400785297,0,0,-0.91500011400785297,"-",0,0,-0.91500011400785297]
["Direct Pumping (Direct Cost)","San Luis WD","-",0.74546543369069695,623054.49918554001,0,623055.24465097371,"-",-1199435.56,0,-576380.31534902635]
["Direct Pumping (Direct Cost)","Westlands WD","4/",5.2320370450615883E-3,5444409.0623097094,0,5444409.0675417464,"-",-7076828.2400000002,0,-1632419.1724582538]
["Direct Pumping (Direct Cost)","Westlands WD DD #2","4/",-0.27078045589765587,18683.777512190896,0,18683.506731735,"-",-9490.76,0,9192.7467317350001]
["Total","Direct Pumping Total (Direct Cost)","-",-227817.58784557058,6716268.3576068794,0,6488450.7697613081,0,-9527404.540000001,576487,-2462466.7702386919]
["Grand Total","Grand Total","-",-227817.58784557058,12502382.342225786,0,12274564.754380215,-5786113.9846189078,-9527404.540000001,576487,-2462466.7702386919]

{"sheet":"PUE Other","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2023 Sch B-6A.Z26"]
["09/25/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION  OPERATION & MAINTENANCE EXPENSE AND PROJECT USE ENERGY COST"]
["BY FACILITY AND/OR COMPONENT FOR FY 2023"]
["2025 IRRIGATION WATER RATES"]
[]
["Facility/Contractor","J) Available From Previous Period **","K) Rate x AF in FY 2023 for \"Other\" Cost","L) Total Available             J+K","M) Applied to \"Other\" Cost 5/","N) Charge Adjustment","O) Unpaid/ (Remaining)   SUM(L:N)"]
["Westlands Water District",-5.431894090725109E-2,-1291029.01,-1291029.064318941,4321276.5323893968,0,3030247.4680704558]
["Westlands Water District DD#2",-0.17592948779070644,-4154.04,-4154.2159294877911,13904.223241743306,0,9750.007312255515]
["Santa Clara Valley Water District",-450071.79321085534,0,-450071.79321085534,0,0,-450071.79321085534]
["San Benito County Water District",-247692.15112551564,-14069.58,-261761.73112551562,47093.090398158609,0,-214668.64072735701]
["Colusa County Water District",-280126.5810447972,-148304.5,-428431.0810447972,496398.41594089608,-67967.34,-5.103901115944609E-3]
["Kanawha Water Districit",0.26526138386907405,-10990.12,-10989.854738616132,36785.654912698948,-25795,0.80017408281855751]
["Orland-Artois Water Districit",-0.95102200093970168,-27250.95,-27251.90102200094,91213.202653220666,0,63961.301631219729]
["San Luis Water Districit",-654810.49017740216,-232867.15,-887677.64017740218,779442.86508279282,0,-108234.77509460936]
["Total",-1632701.9315676163,-1728665.35,-3361367.2815676159,5786113.9846189078,-93762.34,2330984.3630512911]

{"sheet":"Footnotes","index":2,"n_rows":84,"n_cols":6,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2023 Sch B-6A.Z26"]
["09/25/2024"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION  OPERATION & MAINTENANCE EXPENSE AND PROJECT USE ENERGY COST"]
["BY FACILITY AND/OR COMPONENT FOR FY 2023"]
["2025 IRRIGATION WATER RATES"]
[]
["Footnotes"]
[]
["1/"]
["Allocation of Gianelli, WR Pump Generator"]
[]
["Gianelli, WR Pump Generator Costs","Total","San Benito County WD","Santa Clara Valley WD"]
["2023 Storage Deliveries (Excludes 215 Water)",2919,2919,0]
["2023 Storage Deliveries (Excludes 215 Water): Ratios",1,1,0]
["2022 Storage Deliveries (for True-Up)",1616,1616,0]
["2022 Storage Deliveries (for True-Up): Ratios",1,1,0]
[]
["Gianelli (2022 True-Up and 2023 Estimate)","Total","San Benito County WD","Santa Clara Valley WD","All Other Storage Contractors","Grand Total"]
["Gianelli, WR Pump Generator (2023 Estimate)",81334.960000000006,81334.960000000006,0,7370800.7489405703,7452135.7089405702]
["Gianelli, WR Pump Generator (2022 True-Up)",0,0,0,0,0]
[]
["2/"]
["Allocation of Other PUE storage costs"]
[]
["Other PUE Storage Costs"," San Felipe Unit (Storage): Total"," San Felipe Unit (Storage): San Benito County WD"," San Felipe Unit (Storage): Santa Clara Valley WD","All Other Contractors","Grand Total"]
["2023 Storage Deliveries (Excludes 215 Water)",2919,2919,0,1805108,1808027]
["2023 Storage Deliveries (Excludes 215 Water): Ratios",1.6100000000000001E-3,1,0,0.99839,1]
["2022 Storage Deliveries (for True-Up)",1616,1616,0,542831,544447]
["2022 Storage Deliveries (for True-Up): Ratios",2.97E-3,1,0,0.99702999999999997,1]
["Other PUE Offset Storage Cost (2023 Estimate)",517.47,517.47,0,320891.64,321409.11]
["Other PUE Offset Storage Cost (2022 True-Up)",0,0,0,0,0]
[]
["3/"]
["Allocation of Pacheco Pumping Plant costs - Allocation is based on same water delivery ratios as shown in 1/ above."]
[]
["Pacheco Pumping Plant Costs","Total","San Benito County WD","Santa Clara Valley WD"]
["Pacheco PP (2023 Estimate)",16162.3131581702,16162.3131581702,0]
["Pacheco PP (2022 True-Up)",0,0,0]
[]
["4/"]
["Allocation of Pleasant Valley PP, Pleasant Valley Relifts, & Westlands WD Relifts"]
[]
["Pleasant Valley PP, Pleasant Valley Relifts, & Westlands WD Relifts Costs","Total","Westlands WD DD ","Westlands WD DD #2"]
["2023 Storage Deliveries (Excludes 215 Water)",613119,611021,2098]
["2023 Storage Deliveries (Excludes 215 Water): Ratios",1,0.99658000000000002,3.4199999999999999E-3]
["2022 Storage Deliveries (for True-Up)",88103,88103,0]
["2022 Storage Deliveries (for True-Up): Ratios",1,1,0]
["2023 Estimate Pleasant Valley PP",1180195.03863248,1176158.7716003568,4036.2670321230812]
["2023 Estimate Pleasant Valley Relifts",122997.71430000001,122577.06211709401,420.65218290600001]
["2023 Estimate Westlands WD Relifts",4159900.0868894202,4145673.2285922584,14226.858297161816]
["2023 Estimate: Total",5463092.8398219002,5444409.0623097094,18683.777512190896]
["2022 True-Up Pleasant Valley PP",0,0,0]
["2022 True-Up Pleasant Valley Relifts",0,0,0]
["2022 True-Up Westlands WD Relifts",0,0,0]
["2022 True-Up: Total",0,0,0]
[]
["5/"]
["Amount Applied to \"Other Cost\" is a Credit in Accounting for these Contractors."]
[]
["Facility/Contractor","Total Cost FY2023"]
["Storage",5680021.9086943995]
["Direct Pumping",106092.07592450842]
["Storage & Direct Pumping Total",5786113.9846189078]
["Applied (offset/credit) **",5786113.9846189078]
[]
["Note:  Storage Expense Allocation"]
[]
["Storage Expense Allocation Costs","San Felipe Unit Contractors","All Other Contractors","Total"]
["2023 Estimate Gianelli, WR Pump Generator",0,7370800.7489405703,7370800.7489405703]
["2023 Estimate Other PUE Offset Storage Cost",517.47,320891.64,321409.11]
["2023 Estimate Regeneration Credit for FY 2023",null,-2012187.9502461699,-2012187.9502461699]
["2023 Estimate PUE Offset Storage Cost: Total",517.47,5679504.4386943998,5680021.9086944005]
["2022 True-Up Gianelli, WR Pump Generator",0,0,0]
["2022 True-Up Other PUE Offset Storage Cost",0,0,0]
["2022 True-Up Regeneration Credit for FY 2022",null,0,0]
["2022 True-Up PUE Offset Storage Cost: Total",0,0,0]
[]
["**"]
["Project Use Energy O&M cost recoverable through water rates are for Storage and Direct Pumping. Beginning March 2016, there are 8 contractors that pay the Project Use"]
["Energy O&M based on Rates times their Acre-Feet. These 8 contractors receive a credit to their O&M cost for paying WAPA on behalf of others for Storage and Direct "]
["Direct Pumping Project Use Energy.  The credit is offset by allocating the credit to the contractors receiving the service. Any shortages in payment of Project Use Energy"]
["O&M cost will be recoverable in the following year under a similar process (See schedule B-6A for a detail summary of the remaining cost)."]